--initialize jobexp table
go
delete from jobexp
SET IDENTITY_INSERT jobexp ON
insert into jobexp (jobexpid, name, dname) values(1, 'Executive', 'Executive')
insert into jobexp (jobexpid, name, dname) values(2, 'Director', 'Director')
insert into jobexp (jobexpid, name, dname) values(3, 'Mid-Senior level', 'Mid-Senior level')
insert into jobexp (jobexpid, name, dname) values(4, 'Associate', 'Associate')
insert into jobexp (jobexpid, name, dname) values(5, 'Entry level', 'Entry level')
insert into jobexp (jobexpid, name, dname) values(6, 'Not applicable', 'Not applicable')
SET IDENTITY_INSERT jobexp OFF
--initialize jobemp table
go
delete from jobtype
SET IDENTITY_INSERT jobtype ON
insert into jobtype (jobtypeid, name, dname) values(1, 'Full time', 'Full time')
insert into jobtype (jobtypeid, name, dname) values(2, 'Contract', 'Contract')
insert into jobtype (jobtypeid, name, dname) values(3, 'Freelance', 'Freelance')
insert into jobtype (jobtypeid, name, dname) values(4, 'Internship', 'Internship')
SET IDENTITY_INSERT jobtype OFF
--initialize coType
go
delete from cotype
SET IDENTITY_INSERT cotype ON
insert into cotype (cotypeid, name, dname) values(1, 'Startup', 'Startup')
insert into cotype (cotypeid, name, dname) values(2, 'Studio', 'Studio')
insert into cotype (cotypeid, name, dname) values(3, 'Small business', 'Small business')
insert into cotype (cotypeid, name, dname) values(4, 'Mid-sized business', 'Mid-sized business')
insert into cotype (cotypeid, name, dname) values(5, 'Large organization', 'Large organization')
insert into cotype (cotypeid, name, dname) values(6, 'Educational institution', 'Educational institution')
insert into cotype (cotypeid, name, dname) values(7, 'Non-profit', 'Non-profit')
--insert into cotype (cotypeid, name, dname) values(8, 'Recruiting', 'Recruiting')
SET IDENTITY_INSERT cotype OFF

go
delete from EmailTemplate
insert into emailtemplate (emailtemplatetype, emailtemplatename, subject, body, bodyparameter)
values (1, 'sign up email', 
'[JuicyBasket] Confirm your email at JuicyBasket', 
'Hi <Name>,

Welcome to JuicyBasket! Please take a second to confirm <a href="mailto:<EmailAddress>"><EmailAddress></a> as your email address by clicking this link:

<a href="<Url>" target="_blank"><Url></a>

Once you do, you will be able to opt-in to notifications of activity and access other features that require a valid email address.

JuicyBasket Team
http://juicybasket.com

----------

If you received this message in error and do not have a JuicyBasket account, you can simply ignore it or let us know at <a href="support@juicybasket.com">support@juicybasket.com</a> and we will investigate.'
, 
'<Name>,<EmailAddress>,<Url>')

